UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2NzJs53b6mHPFdqU8L8W+PPVyPIJyIrI24RPWHahoE4='
WHERE
key_id = 'a0ca238ad9d7098e268c6040e8baee7a27ab16ea6ba8a6c2750b39e77387fd4d'
AND (
token = '2NzJs53b6mHPFdqU8L8W+PPVyPIJyIrI24RPWHahoE4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)