UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7Gn32yCKwQnyoYVyG9h+NZ0QZE9z0DaFUPkSTfDlB3I=' 
WHERE 
  key_id = '1749fc75bb0c2f5a1e9e06830a7dcdb84c2630cefd822b46d3f330c2b15df3ef' 
  AND (
    token = '7Gn32yCKwQnyoYVyG9h+NZ0QZE9z0DaFUPkSTfDlB3I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00053