UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mCL+WTbLXdgPtzft4a0skODtOATHv4c6KMzm9UHhk3M='
WHERE
key_id = 'e167b234bc88d33ca4e9a1a49fa3031f3e1cf9db2d85a224a6ee8f254784bc2d'
AND (
token = 'mCL+WTbLXdgPtzft4a0skODtOATHv4c6KMzm9UHhk3M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)