SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '9ac978397145cc96a1d2b0cd002868aa0c769da6b9edee3f4a332946b90e7fad' 
  AND token = 'XphvKBMMGoK/KhBj/ept1dKN/j4YBi31cKUcZ0oY2uo=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00020

JSON explain

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