UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n1mtwPmtkOYQ1/h2QgyIt7F3aUergevbzLS15hPXxOw='
WHERE
key_id = '5df6eb7ccd9426446bdcbfb7754bdeeefdf042ebf7d902e487df2e5f8421b8b2'
AND (
token = 'n1mtwPmtkOYQ1/h2QgyIt7F3aUergevbzLS15hPXxOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)