UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9vRh+5NoXv+jOS7m9Cc5vqSHwC+qRKPOvxrjr93L2Qk='
WHERE
key_id = 'cc4327b71b6ea05f71480e9cdc3101fb384b30caecb32e21fba5f56ebff61bf0'
AND (
token = '9vRh+5NoXv+jOS7m9Cc5vqSHwC+qRKPOvxrjr93L2Qk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)