UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NCKgZhXsT60wBzaEZV83oQuaUi4mKkKJaSXRXFMNKn8='
WHERE
key_id = '2bf8c693ddfc3e2d494f2d33e314a0e4fa50a992d3a0bbe42e07cb50efd6a34d'
AND (
token = 'NCKgZhXsT60wBzaEZV83oQuaUi4mKkKJaSXRXFMNKn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)