UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b76LKEVhy8ioJ65ZIgRf3GSsrJHf05HFl3fHEAJmo5g='
WHERE
key_id = '0cd71119d2c00feb4ee87c6c1cfb4093ac885f454f2181a96cd01fe2c6ee9283'
AND (
token = 'b76LKEVhy8ioJ65ZIgRf3GSsrJHf05HFl3fHEAJmo5g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)