SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '56e2ae66dc6060e89d3525ce92fdaa299d388d556a6c9f4fc0924db3f8dedab5' 
  AND token = 'znF8V4XK9xSXFkpHda/dif1JKAb/aJgmi9FKMHowpRI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00027

JSON explain

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