UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r3k6vIw1/0mAKx6iXcYgB+YfMb8qFHqWSahHbziFlp4='
WHERE
key_id = 'c81ed38a58860e9d4754846216c2d3806eb1115f9efccd81aad50b0d74dd0232'
AND (
token = 'r3k6vIw1/0mAKx6iXcYgB+YfMb8qFHqWSahHbziFlp4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)