UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8QbDXwYvqkN53YQSArFxRwzfHCxOt8gZzRyXBvyLheM='
WHERE
key_id = 'a5e6f2de205bbb7d5ee3294b6543d5a664f8a7b22ee5ca5765dfd8e18a1e881f'
AND (
token = '8QbDXwYvqkN53YQSArFxRwzfHCxOt8gZzRyXBvyLheM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)