UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dX9JeSau2+3iuKB7RXnmxCVO6bNqnpetM8LyGP5h1FE='
WHERE
key_id = '2540e2f797685caaf5ecb95302506e23849ccacfd361f5b0294ea7490bf17d80'
AND (
token = 'dX9JeSau2+3iuKB7RXnmxCVO6bNqnpetM8LyGP5h1FE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)