UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WaAffLb8ruuhwpst9Wdegj7YR2iu+VosiKMRtSoiRdA=' 
WHERE 
  key_id = 'da61f7e1371d0511b155207dc24915711cd503399dba00e3a0ee989595863423' 
  AND (
    token = 'WaAffLb8ruuhwpst9Wdegj7YR2iu+VosiKMRtSoiRdA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023