UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5r4KyK1DjJXBdCU36SdsPsIvqe0wPVZXHP9aOUewNqY='
WHERE
key_id = 'e95886fa5d040227687c05bb847ec78070e8613d2c6399b2fd4751f79202189c'
AND (
token = '5r4KyK1DjJXBdCU36SdsPsIvqe0wPVZXHP9aOUewNqY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)