UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dIXp5gTXJEWSjQnbT03VtpG2HIxdh5H5qznOdx52MrI='
WHERE
key_id = '35bf44c96195d3900f0bb0b720c8a44afe34869be7c31b2704ad29fe88218bb2'
AND (
token = 'dIXp5gTXJEWSjQnbT03VtpG2HIxdh5H5qznOdx52MrI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)