UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hpIlpkj1M49IRkDPJtlZTMsFBxBrVxiLTmaHMudPSck='
WHERE
key_id = 'e2e7d11c1f2d1ef6f1a2a731ab2bfd62ba89f1709b414df1b7bc1f5466d1f553'
AND (
token = 'hpIlpkj1M49IRkDPJtlZTMsFBxBrVxiLTmaHMudPSck='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)