UPDATE 
  cscart_june_setuplock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZgjIN4WMcFH6X/p2cU9OK0t/g+AO0BSdQnTy72+j6zY=' 
WHERE 
  key_id = '0a571a648cf8a8f04b597ec1eb0c750e84b10f7d6efcbcd0006dd020cb4f0e54' 
  AND (
    token = 'ZgjIN4WMcFH6X/p2cU9OK0t/g+AO0BSdQnTy72+j6zY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030