SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '79a7e98b169a33ffdf988647c3742cb53b1ffad43d6ea64735bbaef6202d82f2' 
  AND token = '02b6LPuDrKDQeQXCuYagyU4ySfqWNU5kfKIIkPF3xjs=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00020

JSON explain

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