UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DeHBUVOZGgu1ZpFR/P9iFV41vifBkbE4VUjh04UbDLU='
WHERE
key_id = '9813a2734778d11c4890880384a81964016bfa50009454ccf84b54d3de89a8f6'
AND (
token = 'DeHBUVOZGgu1ZpFR/P9iFV41vifBkbE4VUjh04UbDLU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)