UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NHOT6SrfSHR8jXth4rFxDQqaOBKfWCdvZ7e79ffoiRo='
WHERE
key_id = '4184da13f7f54834f8f1136d3c1b6adb23606f4ecb49f80ff54e9abaa792a1f1'
AND (
token = 'NHOT6SrfSHR8jXth4rFxDQqaOBKfWCdvZ7e79ffoiRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)