UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gU0KfiEARoXW8N5GHGKAEQ6yTrZrLnvc4aIWlbaw2to='
WHERE
key_id = '02afcbe6a594b7d1b28129b8f83ef72830321d6d3ef497f7b43979f5b8cd5ad7'
AND (
token = 'gU0KfiEARoXW8N5GHGKAEQ6yTrZrLnvc4aIWlbaw2to='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)