UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xDzZbsq6In9X5rX0v2MWAwE5TfKPwgatuzrbVz1nbLA=' 
WHERE 
  key_id = '1678fb36a53906c354ddebe7323c57c9e288c5e0a728b64b5d0c601bbaf2580a' 
  AND (
    token = 'xDzZbsq6In9X5rX0v2MWAwE5TfKPwgatuzrbVz1nbLA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034