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