UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QtlhQOO2j56D8K3/oMyX1wFvZIf6RQTfF8NHcIpAkT4='
WHERE
key_id = '3c784a184ca0568d64adf5ed37a320dae6064b91c0daa25c94dda82e5706114d'
AND (
token = 'QtlhQOO2j56D8K3/oMyX1wFvZIf6RQTfF8NHcIpAkT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)