UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r9siiuAHcpBDgH45snjU7m7oUkoRo/bWOQ7blSprTZc='
WHERE
key_id = 'dbc4caad2d7eb637c32c332e2bf783e42a69094263b86c2fdccb033264eff4e1'
AND (
token = 'r9siiuAHcpBDgH45snjU7m7oUkoRo/bWOQ7blSprTZc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)