UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mEJMLMLCenQPZM/7Rlbv4LO4pFBiAUux9mxHPionRtU='
WHERE
key_id = '3138a2703cbfdbd8e3b3b4fb9693b4a9f3bd1e78c9f8fba2b18115cd762d29e3'
AND (
token = 'mEJMLMLCenQPZM/7Rlbv4LO4pFBiAUux9mxHPionRtU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)