UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'RG5J6ZteGBMtQVByzFiSMHpOK4b24LUZ1++x0vYYVpw=' 
WHERE 
  key_id = '9dcfc5237f6df8d4256ec695c575136452c179c777fe8a43b800154cee4b9cfc' 
  AND (
    token = 'RG5J6ZteGBMtQVByzFiSMHpOK4b24LUZ1++x0vYYVpw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020