SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'ce31ee713a8a6a2f5311fae71daee57b9d13aabb738556935d1cde3fbdc65694' 
  AND token = 'fNS3pZG9Y5rq7mjDmqQK7Zz6WdKoLT3vkm+ui97d42I=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00027

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}