UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'PT0ganwDCdawae82J2DNfb3nOWN+5a2mXyM//qU/RCA=' 
WHERE 
  key_id = '9f6729102d306c03e614a4208dd686723b7a75a3044a5add800153882d955e66' 
  AND (
    token = 'PT0ganwDCdawae82J2DNfb3nOWN+5a2mXyM//qU/RCA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021