SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'c05117b75bc68cb5227436034eff47ba2541b75bcd9f293aea5c7984e865b7cb' 
  AND token = '/nJ6n6Jd3hP2O9yk00+VPojiuklHge7tpuaWr9zENMw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00025

JSON explain

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