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