UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ab0C8quwJv8kdzOcB8OhnvP1hAAYRZxdXgIk+JQDZlA='
WHERE
key_id = '0511f7ae7a2cb888c0c25f3eb7bff2d6e27efcf9f02269945f5c4398c8cec624'
AND (
token = 'ab0C8quwJv8kdzOcB8OhnvP1hAAYRZxdXgIk+JQDZlA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)