UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zhM8HGhDIvjfgVyuvJYcVWaZW4l4nI0nlMtpslAmFo8='
WHERE
key_id = '47526e2490060bb12f0b4fe9a8a314775ba3b99b3be55557e1f6896bea9ce4b8'
AND (
token = 'zhM8HGhDIvjfgVyuvJYcVWaZW4l4nI0nlMtpslAmFo8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)