SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '2dd3703d5be713b5e69a839aba111c2f34fcea95d8b46da89618838d6aa4ab8e' 
  AND token = 'B+7T0tcaLsid0lmHWvoUVb6DM9m41oArIVfSEjM4Ln0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00016

JSON explain

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