SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '917d55534192b0d4736163b887d4d784bbc8e1f29a140f1e99f04a6d9ed29b86' 
  AND token = 'A2RZz4eg/WIxdJba4nqS7rhBB0BSMxNXOjbpNcTpaRw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00021

JSON explain

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