UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6RXr+bPuOuNDLZL4GkeUiQu4yYF+JXOp2ZrtO4/swJc='
WHERE
key_id = '2740a1d4562af87a575e425eb53124d055305510755de1716f4bc3ba35583eec'
AND (
token = '6RXr+bPuOuNDLZL4GkeUiQu4yYF+JXOp2ZrtO4/swJc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)