UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'U+y8V00x69Q25Y+ew57KubUa0SMl6sW3nHGmln2y6S8=' 
WHERE 
  key_id = 'd03070a1d5b16ce6939f160cf8e1565265a6d50d917ca343ef04564afeb17f9a' 
  AND (
    token = 'U+y8V00x69Q25Y+ew57KubUa0SMl6sW3nHGmln2y6S8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022