UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FL4FY3E0f49ozorObV02Ufkn/2h+qME9/Ps1fA3Sh2c=' 
WHERE 
  key_id = '4f06201ca3b1aefe30227bebcc87172428046983ba099e0ab1adce6d5351e7b5' 
  AND (
    token = 'FL4FY3E0f49ozorObV02Ufkn/2h+qME9/Ps1fA3Sh2c=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035