UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oMiLLF6YYpQpVRiwkLOOicll46WuUGlr/BPeu0MjMgI='
WHERE
key_id = '0d51e14fce31d37f5802e1245f7c1ceb043b105a4defff8caabf9b0120b3f2fa'
AND (
token = 'oMiLLF6YYpQpVRiwkLOOicll46WuUGlr/BPeu0MjMgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)