UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rTTugTFzjj48kfU+5RiToipLX4m5ESMomPkifnq1MA8='
WHERE
key_id = '6d402e24f564b7db925c902d73e98951786cb9a03cdf26fe660158f231c1e99a'
AND (
token = 'rTTugTFzjj48kfU+5RiToipLX4m5ESMomPkifnq1MA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)