UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iF6V9KoJ8zr1Lt6r3vBSCLqFXp5fwt5lP0ZrCJHuZAA='
WHERE
key_id = 'be2e3cec6b76057f6cf660674ab673e7a4c5050c0372b2c5e7e862d0bdfc0f37'
AND (
token = 'iF6V9KoJ8zr1Lt6r3vBSCLqFXp5fwt5lP0ZrCJHuZAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)