UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T8gYlqtkugIdeSDZgA3hGlGszgytFZv1osaw0hUVgpA='
WHERE
key_id = '042f2406c2e36e069023c6d8aeea281d27fcda7b848eabf53f909682776ec2e4'
AND (
token = 'T8gYlqtkugIdeSDZgA3hGlGszgytFZv1osaw0hUVgpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)