UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xE1fRCs4+Fufya95r/YMeOPcXMrnRQ2p9muir0u2UoU='
WHERE
key_id = 'bde31ea38fc1ee99f9ea6b39de35c8fdb11a0007969689b6ef274b65cbeb596c'
AND (
token = 'xE1fRCs4+Fufya95r/YMeOPcXMrnRQ2p9muir0u2UoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)