UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2rYbLfLwlprKI0CYMelPHzU6MuMBPg6Gr+ACcg4Aci4='
WHERE
key_id = '45db9d9f254b68e32c950c683f1cadd65989659a84b64f721dfe233e661cdae2'
AND (
token = '2rYbLfLwlprKI0CYMelPHzU6MuMBPg6Gr+ACcg4Aci4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)