UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'YqD/sW5PzfCpjZC36K8yZ9fRaPxh3mcQIE9RQj6YLyg=' 
WHERE 
  key_id = 'b872a97674e36e274e30ebb2ca8395197dda825ed531b94ee609d648ac005575' 
  AND (
    token = 'YqD/sW5PzfCpjZC36K8yZ9fRaPxh3mcQIE9RQj6YLyg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048